UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQ2NrXDctB4lpA6YGA4+4DDEjk6qrUJoxz0J2ZL7ag0='
WHERE
key_id = 'a7b844a254f2700a2cedf3f7eaeee082c0ce1fb754c519dce9fdbee890170ac0'
AND (
token = 'yQ2NrXDctB4lpA6YGA4+4DDEjk6qrUJoxz0J2ZL7ag0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)