UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpjphMd80RHOZvF9zhKbTp5SET0/7J1j5ogwOPN+KMw='
WHERE
key_id = 'a4eddda9bbd8617f77f229fe69cf19dd89a5d3203b939cc96cf0cfe97ba9aefd'
AND (
token = 'zpjphMd80RHOZvF9zhKbTp5SET0/7J1j5ogwOPN+KMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)