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