UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ej6PBbDZIn+unYytFQolD3mOysKTlVp0f+S1PX6COtk='
WHERE
key_id = 'a5c99713494d7e64cad8175e9ef3846ffb4b8a080eb96296ed24316b46c5ccd8'
AND (
token = 'Ej6PBbDZIn+unYytFQolD3mOysKTlVp0f+S1PX6COtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)