UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ys0fQLbhltrKxQ3H/1rziceE+TJ10h8chVpIYfcZlpE='
WHERE
key_id = '0550c2b2b8209742e87073995c2a57dea58236e93dcbc1fb5604becce5f502ab'
AND (
token = 'ys0fQLbhltrKxQ3H/1rziceE+TJ10h8chVpIYfcZlpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)