UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3YvTGM3pDwpUdBxnwQpj4BqRuBO+MV9zvO5UQYf9X0='
WHERE
key_id = '6a514e6358f0a6c8a476d5e64ab7641ad8aa799cf1853d28ed08add2278cbbf1'
AND (
token = 'B3YvTGM3pDwpUdBxnwQpj4BqRuBO+MV9zvO5UQYf9X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)