UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5iuVlsgZypeqdXx70EMSvv01m79H317u8Tf8RTaaQ+w='
WHERE
key_id = 'fa59d02439a61a9cc3cffe325f8723fa450ae675d2bd7ee197a0a58f172b934a'
AND (
token = '5iuVlsgZypeqdXx70EMSvv01m79H317u8Tf8RTaaQ+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)