UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1drlM/Sn3D+q98/Kn8sUzonlOjXBIEmKcQ5pS5uQJFk='
WHERE
key_id = 'f03781409f0c27cb45deb28744aa249609262d1c1617f04a2beb5f156e2155bd'
AND (
token = '1drlM/Sn3D+q98/Kn8sUzonlOjXBIEmKcQ5pS5uQJFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)