UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAN2Ci5+KwTYlsvRG484ZOW589Wm+AeO4JylX68HkX0='
WHERE
key_id = 'd2f220cf4c2c5ab2f83558eeb76f321e036e2e5d34066d7d78952c334a2f12b6'
AND (
token = 'oAN2Ci5+KwTYlsvRG484ZOW589Wm+AeO4JylX68HkX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)