UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0M7pk+nGF/GKBjXu+lNROED2uwYiPCPbm8umXRyqdHU='
WHERE
key_id = '867d1998c9830ddd1e84c6e551faf933502f2abb3c5f780d8ca92a06b4ccd648'
AND (
token = '0M7pk+nGF/GKBjXu+lNROED2uwYiPCPbm8umXRyqdHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)