UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0u8O5Gc2dhcoLcq5aKJ6eV06jjuC+TSHRLYIcLUy0EA='
WHERE
key_id = 'ccdc200b9903320fb44863e58477ea7c5ea55acd2c10296a22344b6e28f90108'
AND (
token = '0u8O5Gc2dhcoLcq5aKJ6eV06jjuC+TSHRLYIcLUy0EA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)