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