UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dNremlK55WWnjdomTkzCvSn1w9TDUBwyBEciNH+1nYA='
WHERE
key_id = '1cfd27c1f978644a5d24d59c868f918d4e07f0135d235de8366fee819438f3c2'
AND (
token = 'dNremlK55WWnjdomTkzCvSn1w9TDUBwyBEciNH+1nYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)