UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jjFz6YztIBK6XpXSVG6Xo3ofJShOJqDAWga+hFIT+po='
WHERE
key_id = 'd0aa180029a989a668eaf81a81da6929a8ed31f0d74d0c532a621fb0c0054f95'
AND (
token = 'jjFz6YztIBK6XpXSVG6Xo3ofJShOJqDAWga+hFIT+po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)