UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6yLfhEtATElNu2kM1wQZTKE3eZwQc5zw56EGzNoplBA='
WHERE
key_id = '831938f4d2df1072e132bddae48b471ed52ada0dccea9fc42dcb88151f238c72'
AND (
token = '6yLfhEtATElNu2kM1wQZTKE3eZwQc5zw56EGzNoplBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)