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