UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsX59oSM0dkQDj86dX+hvREWrdYQufuIU7ADZKKNYQk='
WHERE
key_id = 'a6b1c7bdea9d9d739d66d193b5382904d06ee552535739d6e05098a86a82b317'
AND (
token = 'QsX59oSM0dkQDj86dX+hvREWrdYQufuIU7ADZKKNYQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)