UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xz0s/80HkYPs6NQHSi+9YvFdcBVBwSc50E5RR4AVXaI='
WHERE
key_id = 'b9f8c3202a09b4d479a7b02ee96fb4d88a0e61b3affc0072b484716a27fe224f'
AND (
token = 'Xz0s/80HkYPs6NQHSi+9YvFdcBVBwSc50E5RR4AVXaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)