UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M3JeEbp/6eaR0sAn7w9RHug+tQqhtbFZuTL09Nd+B20='
WHERE
key_id = 'e78bbc14ae4c7635ce8013cfd962e64f3e0556858d58cbb7f07453f0f04c8df9'
AND (
token = 'M3JeEbp/6eaR0sAn7w9RHug+tQqhtbFZuTL09Nd+B20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)