UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yPgqUVsb9OtiRDsXxfoSwbyiCH7I88Im7ArFu5yH7So='
WHERE
key_id = 'f0873cbbb840e070c34305cc5cd553e8fad17febaa7977c67efbb1429d92527b'
AND (
token = 'yPgqUVsb9OtiRDsXxfoSwbyiCH7I88Im7ArFu5yH7So='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)