UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1Q1hl5PNBVEtOoyo1KulCKN4dt2TLuFlUxoPDTDsN0='
WHERE
key_id = '8fb3d8d165ad32cf6722defba324ddbaf5e13177d4d0f6a9fb62a34f76ebafea'
AND (
token = 'p1Q1hl5PNBVEtOoyo1KulCKN4dt2TLuFlUxoPDTDsN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)