UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTRA63oC0VzFL4BU43zF660Ax4JNeeHr9S0yby39ocw='
WHERE
key_id = 'c29cecc4f414d2db12d44575faffda37af44b4b57c7698470a72ec61de462f5c'
AND (
token = 'BTRA63oC0VzFL4BU43zF660Ax4JNeeHr9S0yby39ocw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)