UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gtQyR0dMTZnarMMliPoDLWmgPeKH10eAJxOMQZvZOM='
WHERE
key_id = 'b30ffb05c250447ccdf4180bdf93984c48e0d3f13f90417b9b47c19193f22b62'
AND (
token = '7gtQyR0dMTZnarMMliPoDLWmgPeKH10eAJxOMQZvZOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)