UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xcb/kt7N6CGk5m3mn/XD/ZHEKN7Kums1qUJSH1fvT5s='
WHERE
key_id = '87b6a7a4761669f91a5e2379326a52b96f7c7250f036a7a3b73befda15334eb7'
AND (
token = 'Xcb/kt7N6CGk5m3mn/XD/ZHEKN7Kums1qUJSH1fvT5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)