UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIaLN+sWTt/lxP4YIbFnEt5lFfhIF9I0XVpR9cQCy40='
WHERE
key_id = 'efc0dadf31396ab894f438b711c6518655172734f97712be88d8abe019d0d36b'
AND (
token = 'nIaLN+sWTt/lxP4YIbFnEt5lFfhIF9I0XVpR9cQCy40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)