UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0oK/vja48+aTAVGmn+VWuFm3bkuDBO5G6f4mNlYDK0='
WHERE
key_id = '8ecb51722199eb5507d79b101c57ee47caeeaa1a64a3c854047ec13c065f5922'
AND (
token = '/0oK/vja48+aTAVGmn+VWuFm3bkuDBO5G6f4mNlYDK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)