UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46oL1UCqMxB0XSajBn8fym/u2EPPutYrsGfPtplZRXU='
WHERE
key_id = '195a82326585ee57f6de9a8fd3f3e4082b58568bbecc6dcab7b5161522ed966a'
AND (
token = '46oL1UCqMxB0XSajBn8fym/u2EPPutYrsGfPtplZRXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)