UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sKvGpUT+xArDi7nlX6Ohk8h0s7UyF8qL5phM8N7GuZY='
WHERE
key_id = 'd5170f6be939765f447a27c978d72cbaf451127b671691561c3505b1c7a1c712'
AND (
token = 'sKvGpUT+xArDi7nlX6Ohk8h0s7UyF8qL5phM8N7GuZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)